Forum Discussion

Txtcher's avatar
Txtcher
Helper V
1 year ago
Solved

How To Create A Count With Multiple Filters

I have been tasked with coming up with a backlog report which provides a count of backlogged RS Cases by 2 different counts (Program and Region). I have 3 tables: A RS Case record contains a ...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi Txtcher,

    We appreciate your inquiry on the Microsoft Fabric Community Forum.

    Based on my understanding, there is no requirement to flatten or merge tables in Power Query. The backlog report can be generated directly in Power BI using DAX and relationships.

    Please find attached the screenshot and PBIX file which may assist in resolving the issue:

     

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members facing similar queries.

    Should you have any further questions, please feel free to contact the Microsoft Fabric community.

    Thank you.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Hi Txtcher,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

Based on my understanding, there is no requirement to flatten or merge tables in Power Query. The backlog report can be generated directly in Power BI using DAX and relationships.

Please find attached the screenshot and PBIX file which may assist in resolving the issue:

 

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members facing similar queries.

Should you have any further questions, please feel free to contact the Microsoft Fabric community.

Thank you.