Forum Discussion

gopinathna_'s avatar
gopinathna_
Frequent Visitor
3 years ago

Dax Measure returns Blank value in Visual

Dax Measure returns Blank Value in Visual but working in other dashboard properly and value showing in Dax Studio. Not able to understand the exact issue. Any one can help
Need Help
Dhairya's avatar
Dhairya
Solution Supplier
3 years ago

Check the visual level or page level filters if applied, please elaborate on your issue by sharing a sample dataset, measure, and expected output after removing sensitive information.

gopinathna_'s avatar
gopinathna_
Frequent Visitor
3 years ago
Please find the measure i am using.
 
Measure 1 - Total_PNRRefund_Prem = CALCULATE(
        SUM(PNR_Refund[Refund_Amount]),
        FILTER(PNR_Refund, PNR_Refund[Business_Type]="Retail"
        ))
Measure 2 - PNR Refund (in Cr) = PNR_Refund[Total_PNRRefund_Prem]/10000000
Measure 3 - PNR Refund % (NB) = DIVIDE([Total_PNRRefund_Prem],'New Business Collection'[New Business Collection])
 
Its happening in one particular table only.

 

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

    Hey gopinathna_ 
    Can you please share dummy data that I can copy and try on my system, from the above information I'm unable to solve the exact issue.