Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 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.
Hello, May I know what should I code based on below logic.
Would like to know the number of Unique "PR Number" that is not blank, but the row of "PO number " is blank.
Solved! Go to Solution.
Hi,
This should do the trick :
Count of Unique PR w PO Blank =
CALCULATE( DISTINCTCOUNT( TabPRPO[PR Num] ) ,
FILTER( TabPRPO, ISBLANK( TabPRPO[PO Num] ) && NOT ISBLANK(TabPRPO[PR Num]) ) )
Thank you so much ! it works ! Really appreciate that.
Hi,
This should do the trick :
Count of Unique PR w PO Blank =
CALCULATE( DISTINCTCOUNT( TabPRPO[PR Num] ) ,
FILTER( TabPRPO, ISBLANK( TabPRPO[PO Num] ) && NOT ISBLANK(TabPRPO[PR Num]) ) )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
12 | |
9 | |
9 | |
9 |
User | Count |
---|---|
21 | |
14 | |
14 | |
13 | |
13 |