Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi there
I am looking to impliment a measure to use in a matrix that provides a total count of a column based on today's date BUT also have it output a text value of "No Data" when there is no data available i.e. Blank.
Using a filtered value quick measure within a matrix produces the desired output when today's data is available:
Measure = IF(ISBLANK(CALCULATE( SUM('Table' [COUNT]), 'Date DIM Table' [Today] IN { TRUE } ), "No Data")
This should work
Hi there
Thanks for your quick reply, however, I get an error when I use this saying that too many arguments were passed to the ISBLANK function?
Sorry, should be an extra bracket to close the calculate:
Hi again
This seems to be working partly (so am getting "No Data" showing when there is no data) but nothing when there is.
Is this because I have not provided a result if true statement in the IF clause? If so, I am assuming that I would just need to do the following?
Measure = IF(ISBLANK(CALCULATE( SUM('Table' [COUNT]), 'Date DIM Table' [Today] IN { TRUE } ), "No Data", CALCULATE( SUM('Table' [COUNT]), 'Date DIM Table' [Today] IN { TRUE } )
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!