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.
Hello, I want to measure the difference between values in two different matrixes. They have a slicer which defines the periode of time of registered data.
The values are counted.
Thank you
Solved! Go to Solution.
Thank you.
I am blocked at calendar. I want to measure the % of difference between outputs of periode 1 (from 01.01.2017 to 31.12.2017) compared to periode 2 (from 01.01.2018 to 31.12.2018).
measure = VAR select1 = ALLSELECTED ( Tabelle1[Bezugsmonat].[Date] ) VAR select2 = ALLSELECTED ( Calendar(date(2018;1;1);date(2018;12;31))) RETURN CALCULATE ( SUM ( Tabelle1[idemploy] ); FILTER ( ALLSELECTED ( Tabelle1 ); [Bezugsmonat].[Date] IN select1 ); VALUES ( Tabelle1[idpart1] ) ) / CALCULATE ( SUM ( Tabelle1[idemploy] ); FILTER ( ALLSELECTED ( Tabelle1 ); [Bezugsmonat].[Date] IN select2 ); VALUES ( Tabelle1[idpart1] ) )
I updated the file aswell.
Hi @piv3z ,
Power bi not support to cache history visual data based on your selection, you need to add another slicer with unrelated date field.
Measure = VAR select = ALLSELECTED ( Table[Date] ) VAR select2 = ALLSELECTED ( Calendar[Date] ) RETURN CALCULATE ( SUM ( Table[amount] ), FILTER ( ALLSELECTED ( Table ), [Date] IN select ), VALUES ( Table[idpart] ) ) / CALCULATE ( SUM ( Table[amount] ), FILTER ( ALLSELECTED ( Table ), [Date] IN select2 ), VALUES ( Table[idpart] ) )
Regards,
Xiaoxin Sheng
Thank you.
I am blocked at calendar. I want to measure the % of difference between outputs of periode 1 (from 01.01.2017 to 31.12.2017) compared to periode 2 (from 01.01.2018 to 31.12.2018).
measure = VAR select1 = ALLSELECTED ( Tabelle1[Bezugsmonat].[Date] ) VAR select2 = ALLSELECTED ( Calendar(date(2018;1;1);date(2018;12;31))) RETURN CALCULATE ( SUM ( Tabelle1[idemploy] ); FILTER ( ALLSELECTED ( Tabelle1 ); [Bezugsmonat].[Date] IN select1 ); VALUES ( Tabelle1[idpart1] ) ) / CALCULATE ( SUM ( Tabelle1[idemploy] ); FILTER ( ALLSELECTED ( Tabelle1 ); [Bezugsmonat].[Date] IN select2 ); VALUES ( Tabelle1[idpart1] ) )
I updated the file aswell.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |