Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
25 | |
17 | |
11 | |
10 | |
10 |
User | Count |
---|---|
35 | |
28 | |
19 | |
16 | |
13 |