I have the following as an example
Ref Person Stage Fact
1 122 1 0.33
1 122 2 0.33
1 122 3 0.33
2 44 1 1
3 67 1 1
I want a measure (or column) That I can drag in to show the Summed Number of Facts where the fact is less that 1. Because if its less that one it means that Person is against the ref more than once.
In SQL Id do SELECT SUM(Fact) FROM TABLE WHERE Fact<1 But I cant quite figure out how to do it in DAX.
I tried to add it seperately as a filter but it doesnt seemt to work
Solved! Go to Solution.
this is called Binning. you can read more on how to use it here:
and if the binning function is not working for you, you can try the SWITCH function like below
Im sorry I dont really understand how to apply those examples to what Im Want to do.
For example I want a Card showing Number of None Multiples 2 And Number of Multiples 1 for this example