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'm creating a dashboard to compare the result in brand level and campaign level. There will be 2 levels of filtering, the 1st slicer filters the brand while the 2nd one will base on the brand selected in the 1st slicer and display all available campaigns.
I need to have 2 sets of results, which one will just show those for brand level, no matter what has been chosen in the 2nd filter. The other set will be down to campaign level.
I encounter a problem with the brand level set result. I'm trying to use the below Measure:
Solved! Go to Solution.
HI, @puglover
Assume that these are two data table and they a relationship by column ID
If you just don't want "campaign name' slicer to affect the measure
you can create a measure as below:
Measure = CALCULATE(AVERAGE(Table1[Qty]),ALL(Table2[campaign name]))
Result:
If not your case, please create a sample pbix file with virtual data, this will be a great help on this issue.
and I think you'd better have a learn on ALL/ ALLEXCEPT Function
https://docs.microsoft.com/en-us/dax/all-function-dax
https://docs.microsoft.com/en-us/dax/allexcept-function-dax
Best Regards,
Lin
hi, @puglover
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
Hi @v-lili6-msft,
Just found out that It acutally shows all the results in slicer 1 no matter what I choose in slicer 1, which that shouldn't be the case as I only need the slicer 1 chosen options to be shown disregarding the one in slicer 2.
And the format has been set in % but still shown as decimal number:(
Sorry as I'm quite new to this, do you mind sharing the method in masking the data so I could share that with you?
Thanks,
ying
hi, @puglover
Select the measure then click Modeling->Formatting to set format as below.
Best Regards,
Lin
hi, @puglover
please share your sample pbix file or some data sample and expected output. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
Hi @v-lili6-msft,
Above are the 2 screenshots that taken from my file.
In the first picture, There's a line chart showing the average audience retention, the dark one is the one with the problem which it shows the same average for "25%, 50%, 70% and VCR%". This is assuming the line will just move based on the selection on the "brand' slicer no matter what other options are taken in "campaign name' slicer.
The second picture is showing the table that I created separately for this graph. (There should be correlated brands under the brand column but I have hided those).
Please let me know if this could help better understand my needs. Thanks a lot!
Best,
Ying
HI, @puglover
Assume that these are two data table and they a relationship by column ID
If you just don't want "campaign name' slicer to affect the measure
you can create a measure as below:
Measure = CALCULATE(AVERAGE(Table1[Qty]),ALL(Table2[campaign name]))
Result:
If not your case, please create a sample pbix file with virtual data, this will be a great help on this issue.
and I think you'd better have a learn on ALL/ ALLEXCEPT Function
https://docs.microsoft.com/en-us/dax/all-function-dax
https://docs.microsoft.com/en-us/dax/allexcept-function-dax
Best Regards,
Lin
HI, @puglover
You could use ALL-function in your measure like:
and here is a blog for you as a reference:
If it is not your case, please share some data sample and expected output. Do mask sensitive data before uploading.
Best Regards,
Lin
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |