Im quite new to power bi. can you please help me here ?
I have a card which counts total values in column A. if if select specific values in slicer sometimes it comes up as (blank) instead of zero.
if i need to create Measure = expression + 0 - what should be under expression ? measure = sum(table[column A]) + 0 ? and how to apply it to the card when the measure is created ?
Has someone created a suggestion to add functionality to the fields to add a 0 if blank? Creating a measure for every card is too excessive and limits functionality......
@aarikc17 someone already submitted an idea but no popularity for it....
Here is a more popular one. There are many more ideas posted that are similar.
Hi @misakkk ,
Right click on the left side pane on any Field name and Click "Add New Measure".
Give a name to the measure. Ex: MsColumnA
Assign your expression and " + 0 " at the end.
MsColumnA = Sum(Table_Name[columnA]) + 0
Now your new measure will appear on the left side pane.
Drag and drop it to the Card Field.
This will be a conference that you do not want to miss!
Don't miss the Power BI Dev Camp this week!
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.