Forum Discussion

manojk_pbi's avatar
manojk_pbi
Helper V
6 months ago
Solved

Calculated Columns or Measure to get the output

Hello Friends,   Please help me to write either DAXm Measure or calculated column in this scenario. I have provided sample input data and expected output in table. We have one master data & report...
Need Help
Show and Tell
Tips and Tricks
  • v-echaithra's avatar
    v-echaithra
    6 months ago

    Hi manojk_pbi ,

    Thank you for your response. I have adjusted the measure accordingly and hope it now meets your requirements. Please review the attached PBIX file.

v-echaithra's avatar
v-echaithra
Community Support
6 months ago

Hi manojk_pbi ,

Thank you for reaching out to Microsoft Community.
Please review the attached PBIX file, which has been configured to match your stated requirements.

Best Regards
Chaithra E.

manojk_pbi's avatar
manojk_pbi
Helper V
6 months ago

v-echaithra , Thanks for creating a sample and configuring the required measures. Few are not working as expected.

 

If I need to present Required Reports, Available Reports count in KPI visual, numbers are not correct. Even the measure is not working properly when we have total in the table. 

Actually available reports are 8 but table shows 4. It is taking distinct count instead it shuld add up all the values. 

 

How can we modify to get the sum of all required and available reports