Forum Discussion
True or False Percent Gauge
Create 3 Measures. First measure would be a simple "CountRows" measure. That will give you the total number of cases. This measure will change depending on your filter context. Next create a 2nd measure which is going to count the number of True rows, this can be done doing something like:
CountTrue = CALCULATE( COUNTROWS('YourTable'), 'YourTable'[Case Solved?] = TRUE() )Lastly the 3rd measure is what is your percentage, which will be the [CountTrue] / [CountAll]
Create 3 Measures. First measure would be a simple "CountRows" measure. That will give you the total number of cases. This measure will change depending on your filter context. Next create a 2nd measure which is going to count the number of True rows, this can be done doing something like:
CountTrue = CALCULATE(
COUNTROWS('YourTable'),
'YourTable'[Case Solved?] = TRUE()
)Lastly the 3rd measure is what is your percentage, which will be the [CountTrue] / [CountAll]
Thank you both.
Ross' was best for my data. Appreciate the help
I created the "CountRows" measure already. I calculated the difference between two dates and for each row has difference, the answer is a number. Can you tell me what I should do to know the percentage of the rows they are 0, dates are same?
Thanks
Hi Guyloucou, i'd love to help you but I can't for the life of me work out what you are asking. Your question didn't seem to make any sense.
Sorry, my first language is French. Let me give you more details. I would like to write a measure to know how many projects are deliver to the target date anticipate. Can you help me?
How can we visualizre this?
