Forum Discussion
Solved
Group by with If Condition
Hello Team, I have this table (Col A and Col B) and I need Output like this in Col F, G, H. Please help me with Power BI.
Musadev
Resolver III
Resolver IIIThe first measure has grouped all the data irrespective of the status (Y,N)
and then it applied a check to count only the Y status and ignore the N.
You can add another measure as well to count the N values for each text, and then minus it from the total count and it will give you the same results.
Hello Musadev
This works -
TBL7 Total Count = COUNTROWS(TBL7)
Original
Now how can I apply Y then Count should be there Else 0 - How CAn I apply