DAX HELP !

[pedrohenriquewe]

These are my tables:
Issues_storylevel (dimension)

key

key-1

key-2

key-3 ...

History (fact)

key-1	A	01/01/2023
key-1	B	01/01/2023
key-1	Block	03/01/2023
key-1	C	04/01/2023
key-1	Block	06/01/2023
key-2	A	02/01/2023
key-2	B	03/01/2023
key-2	Block	04/01/2023

I wanna know the status that the Issue (row-key) was when it has been blocked. The expected result is a table like that:

Status	Value
A	1
B	2

[Anonymous]

Hi @pedrohenriquewe ，

Please consider adding a index column in powerquery editor and then create a calculated column.

and then create a table visual.

Measure = COUNTROWS('Table')

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Ajendra]

Hello Dear,

I hope you are doing well!

Please find below the SCREEN SHOT it may help you!

Here is the demo data which i have used to create this DAX.

[Wilson_]

Hello Pedro,

Thanks for showing your tables and relationships, and your expected result. Much appreciated. I wanted to confirm a few things about the expected result.

What is it displaying? It looks like a count of what status an issue was in when it got blocked? If that's the case, it looks like to me that it should be B 2, C 1? Please let me know what I'm missing.

[pedrohenriquewe]

Wilson, You are correct, my bad.

The correct result should be B2, C1.