Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am making a dashboard that has got calculations. My scenario is this:
I have created a data set that has got different indicators and it is being represented for different hierarchies. Below is the matrix that has KPI's for your reference.
One of the indicators NPAFP rate has different denominator in calculation for Division, District and Tehsil. That is why I plan to create three different columns for NPAFP (two are already there). NPAFP rate formula is below:
Solved! Go to Solution.
Hi @Mughees ,
If your issue is with that COUNT in the numerator taking the blanks into account for the Tehsil measure, you could try this:
COUNT () - COUNTBLANK()
See below:
Sample Table:
Sample Matrix:
Regards,
Hi @Mughees ,
If your issue is with that COUNT in the numerator taking the blanks into account for the Tehsil measure, you could try this:
COUNT () - COUNTBLANK()
See below:
Sample Table:
Sample Matrix:
Regards,
Thankyou. BTW i just applied counta and it resolved my issue preety quickly. thank you though
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.