Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RitaMunha
Helper I
Helper I

Average measure&adapt scale to average&use the number of entries in a graphic afected by slicer

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)

 

image.png

 

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:

image.png

 

image.png

 

The Count should change if i choose different dates

 

Any idea?

 

Thanks in advance

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

6 REPLIES 6
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.

here

 

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

@RitaMunha ,Can you share the formula and data in table format and logic of AAA, BBC and CCC? Difficult to as of now

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.