Forum Discussion

gopinathna_'s avatar
gopinathna_
Frequent Visitor
3 years ago

Dax Measure returns Blank value in Visual

  1. 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

3 Replies

  • 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.