Forum Discussion
StuartSmith
5 years agoPower Participant
Incorrect Percentage Value
I have a table containing 67 row... Count_Total_Row_Measure = COUNTROWS(Services) That contains a column called "VoWiFi" that contains 22 "Yes" values... Count_Rows_Where_No_Measure = CALCUL...
- 5 years ago
StuartSmith , I created
Measure = DIVIDE([Count_Rows_Where_No_Measure],[Count_Total_Row_Measure])Marked it as % type and seems to to give the number you want
StuartSmith
5 years agoPower Participant
Neither of the below changed the result.
Find below a sample file...
https://www.dropbox.com/s/kwhnnio9q2lceu8/Sample.pbix?dl=0
amitchandak
5 years agoSuper User
StuartSmith , I created
Measure = DIVIDE([Count_Rows_Where_No_Measure],[Count_Total_Row_Measure])
Marked it as % type and seems to to give the number you want