Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 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.
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
User | Count |
---|---|
46 | |
26 | |
21 | |
19 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |