Forum Discussion
Measures data not showing
Hi,
I've created a report in Power BI desktop and created a "_Measures" table, created some measures and applied to visuals.
so far so good.
Then I publish the report and then when I click on the report all the data that has a measure it shows "blank".
I'm the owner of the report and I can't find where "special" permissions are or if it's not permissions what I'm doing wrong.
Thank you!
Hi mvasc0ncelos ,
Based on my test, it works fine on my device.
Try to change the column data type from text to True/False.
Then your metric also needs to be modified
OpenTickets = CALCULATE ( COUNTROWS ( 'table'), 'table'[STATUS] = FALSE() )There're some similar posts you can refer to
https://community.powerbi.com/t5/Desktop/Measure-displaying-blank-value/m-p/291610
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Are you using any filter (true/false) at page level, visual level?
In the online report, can you try clicking on 'Reset Filter....' option
You might be filtering the report accidentally. Did you click on a specific visual element?
no filters. I also clicked "reset to defaults" but nothing happened.
I create in the Power BI desktop the table _Measures with the formula _Measures = {Blank()}
For example the measure "OpenTickets"
OpenTickets = CALCULATE ( COUNTROWS ( table), table[STATUS] = "FALSE" )As I said in Power BI desktop it shows everything fine. Online doesn't.Do you have some sample pbix file you can share? So I can take a look in more details
Hi mvasc0ncelos ,
Based on my test, it works fine on my device.
Try to change the column data type from text to True/False.
Then your metric also needs to be modified
OpenTickets = CALCULATE ( COUNTROWS ( 'table'), 'table'[STATUS] = FALSE() )There're some similar posts you can refer to
https://community.powerbi.com/t5/Desktop/Measure-displaying-blank-value/m-p/291610
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
