Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Please help me with below.
I want to use the Same date column as slicer with different value for both Measure A and measure B at any given time. Then, measure-C should calculate the result based on the output of A and B.
Means, visual-1 has Measure/column A ----> with Date slicer -- Let's select any value like 30th June --user can select any value from date in future.
and Visual-2 has Measure/Column B -----> with Date Slicer -- Let's take different value than A like 1st April--- user can select any value from date slicer in future.
Visual 3 will simply add the output for visual-1 and Visual-2.
I am stuck at visual-3. Not able to add the output of Visual-1 and visual-2. Please find the below screenshot for reference.
Please note, user can select any value from Date slicer in future.
Solved! Go to Solution.
Hi,
I think you should be able to complete this using a separate Date Table. I assume that your current Table has a Date Column which you are using. You will need to do the following.
1.Create a new Date Table :
Date:= DISTINCT(Table[Date])
2. Make sure there is no Relationship between the Date Table and the Current Table
3. The DAX for Measure 1 can be just
Measure 1:= var Date= SELECTEDVALUE(Table[Date])
RETURN SUMX(FILTER(Table,Table[Date]= Date),Table[Aggregation Column])
Since, the First Filter would be for this Visual would be from the Dates column of the same Table. This Measure should work.
4. The DAX for Measure 2 can be
Measure 2:= var Date= SELECTEDVALUE(Dates[Date]) RETURN SUMX(FILTER(Table,Table[Date]= Date),Table[Aggregation Column])
5. To Create the Third Measure as a Summation of the above two, you could use
Measure 3:= [Measure 1]+ [Measure 2]
Best Regards,
Vignesh M
If what I suggested worked for you, feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂
Hi @Anonymous , I was able to do some quick tables and measures to add these. Here is my pbix Adding measures
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous , I was able to do some quick tables and measures to add these. Here is my pbix Adding measures
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi,
I think you should be able to complete this using a separate Date Table. I assume that your current Table has a Date Column which you are using. You will need to do the following.
1.Create a new Date Table :
Date:= DISTINCT(Table[Date])
2. Make sure there is no Relationship between the Date Table and the Current Table
3. The DAX for Measure 1 can be just
Measure 1:= var Date= SELECTEDVALUE(Table[Date])
RETURN SUMX(FILTER(Table,Table[Date]= Date),Table[Aggregation Column])
Since, the First Filter would be for this Visual would be from the Dates column of the same Table. This Measure should work.
4. The DAX for Measure 2 can be
Measure 2:= var Date= SELECTEDVALUE(Dates[Date]) RETURN SUMX(FILTER(Table,Table[Date]= Date),Table[Aggregation Column])
5. To Create the Third Measure as a Summation of the above two, you could use
Measure 3:= [Measure 1]+ [Measure 2]
Best Regards,
Vignesh M
If what I suggested worked for you, feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂
Hello,
I have a similar issue...
Let's say that I have 3 measures;
measure MA = avg A * 12
measure MB = avg B * 12
MC = MA + MB
Avg A and B are average per month on related column A and B.
I aplly 1 filter on each measure A and B. It is actually slicers about datetime (period |b| 2 selected dates).
For exemple, A is calculated on 7 months and B calculated on only 3 months (but it can change).
So the slicer determine the period (and not only one selected value as above) on which the average is calculated.
How can I return the value of A and B respectively filtered to get C ?
Thank you
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |