Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 @AkshataRevankar ,
Try to create below measure in the card visual:
Location Data Missing =
IF( COUNTBLANK('Fact'[Location Sold]) > 0 , "Yes", "No" )
Best Regards,
Joyce
Hi @AkshataRevankar ,
Try to create below measure in the card visual:
Location Data Missing =
IF( COUNTBLANK('Fact'[Location Sold]) > 0 , "Yes", "No" )
Best Regards,
Joyce
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
19 | |
18 | |
18 | |
9 |