topic Re: DAX HELP ! in DAX Commands and Tips

DAX HELP !

pedrohenriquewe — Thu, 27 Apr 2023 19:39:58 GMT

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

Re: DAX HELP !

Wilson_ — Fri, 28 Apr 2023 12:16:19 GMT

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.

Re: DAX HELP !

Ajendra — Fri, 28 Apr 2023 20:28:45 GMT

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.

Re: DAX HELP !

pedrohenriquewe — Thu, 04 May 2023 14:25:25 GMT

Wilson, You are correct, my bad.

The correct result should be B2, C1.

Re: DAX HELP !

Anonymous — Fri, 05 May 2023 04:49:00 GMT

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