Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I have been struggling with this exercise, but i think it's time to ask for some help (still to green).
I´m trying to create a measure that is affected by a slicer date. I have to use the measure in a graphic.
Here is a dummy data that represents my problem
My original table:
I need to calculate the average for each user (based on the date interval selected on the slicer)
This is my scale that should convert the average
Scale:
AAA - Average [4;5]
BBB - Average [3;4]
CCC - Average ❤️
Expected Result
If i choose date: 10-03-2020 to 12/03/2020
Auxiliary Calculation:
The Count should change if i choose different dates
Any idea?
Thanks in advance
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi Ashish_Mathur,
That was precisely what I needed
I still can't understand the "count" formula, but I'll try to understand
IF it is possible, please share your reasoning regarding this
I hope to be able to reproduce for my real exercise
tks in advance
You are welcome.
Hi
I´m dealing with a new problem with my dashboard. It seems that i`m not able to filter my list of users based on a scale slicer.
I`ve used the example that @Ashish_Mathur kindly created for me and i`m already using this model in my real dashboard.
I`ve attached a new file to simplify the understanding.
Thanks in advance
Hi,
I do not face any such problem. When i select a scale in the check box or click on a wedge of the pie chart, the table shows data for only the selected scale.
@RitaMunha ,Can you share the formula and data in table format and logic of AAA, BBC and CCC? Difficult to as of now
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |