Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Below is an example of the matrix that counts the category:
Below is an example of the output from the measure I need:
Category | 2022.24 | 2022.25 | 2022.26 |
BCP-06 | 0 | 0 | 1 |
BCP-08 | 0 | 0 | 0 |
Solved! Go to Solution.
Hi @Anonymous
Create a measure like this
Measure =
VAR _DATE=CALCULATE(MAX('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Category]),[Date]<MAX('Table'[Date])))
VAR _VALUE=CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Category]=MAX('Table'[Category])&&[Date]=_DATE))
RETURN IF(MAX('Table'[Date])<>CALCULATE(MIN('Table'[Date]),ALLEXCEPT('Table','Table'[Category]))&& _VALUE<>SUM('Table'[Value]),1,0)
Then add the measure in Matrix visual .
I have attached my pbix file , you can refer to it .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Create a measure like this
Measure =
VAR _DATE=CALCULATE(MAX('Table'[Date]),FILTER(ALLEXCEPT('Table','Table'[Category]),[Date]<MAX('Table'[Date])))
VAR _VALUE=CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Category]=MAX('Table'[Category])&&[Date]=_DATE))
RETURN IF(MAX('Table'[Date])<>CALCULATE(MIN('Table'[Date]),ALLEXCEPT('Table','Table'[Category]))&& _VALUE<>SUM('Table'[Value]),1,0)
Then add the measure in Matrix visual .
I have attached my pbix file , you can refer to it .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |