Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello
This is my scenario. I have the query 1 with my store list and and the query 2 with a table WITH NO NULLS.
When you connect both you can see the table with the column called: store with values or with blanks depending on the query 2.
My problem is that I need to calculate in this table how many rows are blank. since the query 2 has no blanks ...I dont know what to do 😞
Thank you guys!
Solved! Go to Solution.
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below. Please check the below picture and the attached pbix file whether it suits your requirement.
No sales store count: =
SUMX (
VALUES ( Store[Store] ),
CALCULATE (
INT (
ISBLANK (
COUNTROWS ( FILTER ( Sales, NOT ISBLANK ( SUM ( Sales[Quantity] ) ) ) )
)
)
)
)
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below. Please check the below picture and the attached pbix file whether it suits your requirement.
No sales store count: =
SUMX (
VALUES ( Store[Store] ),
CALCULATE (
INT (
ISBLANK (
COUNTROWS ( FILTER ( Sales, NOT ISBLANK ( SUM ( Sales[Quantity] ) ) ) )
)
)
)
)
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |