Measures data not showing

[mvasc0ncelos]

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! 

[Anonymous · Accepted solution]

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/PBI-Service-Visuals-showing-Blanks-and-not-in-Desktop/m-p/9...

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.

[mvasc0ncelos]

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.

[YukiK]

Do you have some sample pbix file you can share? So I can take a look in more details

[YukiK]

You might be filtering the report accidentally. Did you click on a specific visual element?

[mhossain]

@mvasc0ncelos 

Are you using any filter (true/false) at page level, visual level? 

In the online report, can you try clicking on 'Reset Filter....' option