March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello guys
I'm creating a measure to generate an S-curve of predicted and realized as a percentage of existing values.
It turns out that when filtering the entire dataset from one filter, for example, territory, it divides the value between north and south, with south, being 75% and north 25% and the total percentage value of the entire set is 100%.
I need that when filtering the South set, it brings 100% and the North 100%, since it is only that territory.
The measurements I'm using are:
@some_bih
I Attachment a figure to show us about this.
Filter Norte
Filter SUL
All measure in dashboard
My intention is that in a predicted measurement, I can filter the north and south, and, if there is no filter, the total value will appear. And activating the other filters in the report as well
Hi @leandro41 your first measure definition,[Tarefas Media], include DAX function ALLSELECTED, [Tarefas Media].
This is ok if you use that measure for visuals.
Still, in your case this measure is used in another measures which is not good practice as results are almost impossible to figure out what are they.
Best practice for ALLSELECTED: use it for visuals not as input for other measures.
Rewrite code/s or provide simple file with input and expected output to provide possible solutions. Your request seems regular 🙂
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
23 | |
16 | |
15 | |
7 | |
6 |
User | Count |
---|---|
33 | |
29 | |
16 | |
13 | |
12 |