Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I have attached 2 screenshots below. Not sure if that is what you are looking for?
I have attached 2 screenshots below. Not sure if that is what you are looking for?
Thanks
Ill see what I can do with that
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
https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning
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
@DebbieE I guess you are looking for a sum of first 3 records which will be .99, is that correct?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
It should sum to 1. Ive just shown as 2 digits. This is a screenshot
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |