Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
in continue to my previous post (reference), i have these two tables:
and they are both connected by WW.
then i created this tablet that sum the total hours of every ww depends on the slicer choice (as you can see the slicer is on the priority).-
now, what i want to get is another column that will calculate the total hours depends on slicer selection (in this case - 14).
here is what i would like to get-
i know i need to create a measure that will calculate it because i want it to change according to the slicer selection, but i just don't know how to do it.
can someone please help me with it?
Solved! Go to Solution.
Hey,
this will calculate the Total No. of hours:
Total No. of Hours = CALCULATE( SUM(Table1[No. of hours]) ,ALLSELECTED(Table1) )
Here is a little screenshot:
I already added this measure to the pbix file that I used for my answer in your reference post.
Hopefully this is what you are looking for
Regards
Tom
Hey,
this will calculate the Total No. of hours:
Total No. of Hours = CALCULATE( SUM(Table1[No. of hours]) ,ALLSELECTED(Table1) )
Here is a little screenshot:
I already added this measure to the pbix file that I used for my answer in your reference post.
Hopefully this is what you are looking for
Regards
Tom
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |