'I want to display a count distinct in Power BI, using the filters in a matrix view
I am putting exception report together on financial data and want to count the number of errors in a report and display it on a summary page. The detail is sitting on a Power BI Matrix. I can count the exceptions in the Matrix, but want to display that count on a card.
From the below matrix, I want to show the 118 on a card. It however seem to be an issue given the context on the Matrix.
I have tried to add a card and apply the same filters, but that is not possible given the context in the Matrix.
The filters in the matrix are:
- 2 months (Dec 2020 and April 2022)
- Delta where the difference in balance between the two periods above are zero (This is a measure)
- Total which is a measure of the sum of the balance between the two periods above. I excluded all zero's here to reduce the size of report
- Filter on "Level 1" which just reduce the number selection to specific type of accounts.
- I am comparing at CC_GL level which is a unique id which I also count in the end to get the 118.
Is there a way to do this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

