Forum Discussion
problem with counting rows where a slicer has blanks
Hell all, i am new to power BI and got stuck with a problem. I am trying to update daily response rate in a dashboard. I have created three new measures: total invitation = countrows(Sheet...
Irwan
Super User
Super Userhello flying_bird
please check if this accomodate your need.
1. create a new measure with following DAX for Total Invitation
Total Invitation =
CALCULATE(
COUNTROWS('Table'),
ALL('Table')
)
2. create a new measure with following DAX for Cumulative Response (exact same DAX as yours)
Cumulative Response =
CALCULATE(
COUNTROWS('Table'),
FILTER(
'Table',
'Table'[Response Date]<=MAX('Table'[Response Date])&&
not ISBLANK('Table'[Response Date])
)
)
3. create a new measure with following DAX for Response Rate (exact same DAX as yours)
Response Rate =
DIVIDE(
[Cumulative Response],
[Total Invitation]
)
Hope this will help.
Thank you.
This seems not working... but thank you for trying.