Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
New to dynamic calaculations, need help.
Table A (Dimension, Slicer)
Product Id Product Name
123 abc
234 def
Table B (Fact, Table Visual)
Product Id Sold date Location Sold
123 12th sept NY
123 15th Sept
234 11th Sept NY
234 15th Spet ATL
Report -
1. Has a slicer to pick product id
2. A table, or card visual to show a "Location Data Missing" flag as "Yes" if there any null/blank values for the "Location Sold" field.
For the above table data example - when the slicer is filtered for Product Id 123 - The "Location Data Missing" will be "Yes"and for Product Id 234 it will "No"
Need help creating a calaculated column or measure, not sure how to get started.
Solved! Go to Solution.
Hi @Anonymous ,
Try to create below measure in the card visual:
Location Data Missing =
IF( COUNTBLANK('Fact'[Location Sold]) > 0 , "Yes", "No" )
Best Regards,
Joyce
Hi @Anonymous ,
Try to create below measure in the card visual:
Location Data Missing =
IF( COUNTBLANK('Fact'[Location Sold]) > 0 , "Yes", "No" )
Best Regards,
Joyce
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
21 | |
20 | |
14 | |
12 |
User | Count |
---|---|
20 | |
19 | |
18 | |
13 | |
13 |