Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
17 | |
17 |
User | Count |
---|---|
30 | |
25 | |
18 | |
15 | |
13 |