Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Community,
I have created a new table from another table. and i want to get a value based on seleceted value on slicer.
The slicer called Situation.
In the new table i want to bing ALL the values from MR/365 based on selected value from Situation.
So basiclly as the Situation changes in the slicer i need th data in MR/365 change accordingly.
This is the new table:
This is MR/365 ( it's a calculated measure):
MR/365= DATEDIFF (SELECTCOLUMNS(TC,"SITUATION",SELECTEDVALUE(TC[Situation])),SELECTCOLUMNS(BTA_Output,"Maturite",BTA_Output[Maturite]) ,DAY)/365
Thanks.
@DYY94 , You can not use selected values in calculated table and Column
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |