Forum Discussion
Summarise measure output
Hi guys,
Can I get your help on an issue I've been trying to tackle? I'm trying to summarise/aggregate outputs of a measure.
For example my initial data set is:
| Location | Name | Number of Visits |
| A | A | 1 |
| B | A | 3 |
| C | A | 8 |
| D | A | 29 |
I want to flag all number of visits >5 using a measure so I'll use an IF function in DAX. I'll use a matrix visualisation and produce something like; where 0 = the rule is not triggered (i,e, visits <5) and 1 = rule is triggered (visits >5).
| Location | Name | Number of Visits |
| A | A | 0 |
| B | A | 0 |
| C | A | 1 |
| D | A | 1 |
Now I want to aggregate these results into summary statistics e.g.
There are 2 0s and 2 1s or 50% of the result of the measure is 1 and 50% is 0s.
What function should I use to produce these summary statistics?
Thank you for your help!!
1 Reply
- kentyler
Solution Sage
Count the number of locations.
Sum the number of visits.
Divide
