Forum Discussion
DenbyG
9 months agoFrequent Visitor
Distinct Count
Hi, I would like to do a distinct count of all the items in a coloumn 'LAR' that is ZPROG001, and all the items in another column, 'AES' that is 10 or 11, in Power Bi. I've tried several different DA...
- 9 months ago
Brilliant. Thank you. I appreciate that. It is CountRows.
Shai_Karmani
Super User
9 months agoYou can do this with a simple CALCULATE+ DISTINCTCOUNT.
If you want the distinct count of rows where LAR = "ZPROG001" and AES = 10 or 11, try:
meas_Count_LAR_AES =
CALCULATE(
DISTINCTCOUNT(YourTable[YourRowID]),
YourTable[LAR] = "ZPROG001",
YourTable[AES] IN { 10, 11 }
)
Replace YourTable with your table name and YourRowID with a unique row column.
If LAR is already unique per row, you can also distinct-count LAR directly:
meas_Count_LAR_AES =
CALCULATE(
DISTINCTCOUNT(YourTable[LAR]),
YourTable[LAR] = "ZPROG001",
YourTable[AES] IN { 10, 11 }
)
Shai Karmani | Data & Analytics
If it helped please mark as resolved & give a kudo so others can find it too.