Forum Discussion
Solved
show items with no data
I have a table where I want to show data for for instance Feb 2017 but also a running total for all categories not just those with data in Feb 2017. I have a slicer in Power BI to select the Feb 201...
You will have to use a Academies table.
And map the proper relationship.
Then use a Measure to show 0 when the academy is missing.
CNT MEASURE = IF(ISBLANK(SUM(YourTable[cnt])),0,SUM(YourTable[cnt]))
You will have to use a Academies table.
And map the proper relationship.
Then use a Measure to show 0 when the academy is missing.
CNT MEASURE = IF(ISBLANK(SUM(YourTable[cnt])),0,SUM(YourTable[cnt]))