'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?

View of matrix and filters



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source