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 have the following Dax Statement below that is creating a score for two filtered measures and adding the score together.
Measure =
CALCULATE (
DISTINCTCOUNT ( 'Table'[case] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -12 ) )
) * 20
+ CALCULATE (
DISTINCTCOUNT ( 'Table'[case] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -60 ) )
) * 5
I now just want to add another filtered measure to the total but i dont need it to look back a year. I just need the measure to be filtered by specific value or category of the values if that makes since? Because if i use a slicer it will scew the actual measure up and filter the data as a whole rather than the specific information i need.
Below i have attatched the visuals as well. The total i am trying to reach is 70. Right now i have just the admissions added together with the dax i provided above. For instance for this next added part of the measure i am looking for if a case has a waiver of ABC then create a score of 20. I then would like to add that to the other dax i have above creating a total score of 70.
Any help would be greatly appreciated as i am not finding much on creating a totaled filtered measure.
Thanks!
Solved! Go to Solution.
Thanks for the reply. Here is what i ended up using.
Hi @Anonymous ,
Sorry we cannot understand your requirement clearly, but it seems you want te sum up [Measure] and [Waiver] and get the result of 70? Try to add the [Waiver Score] should get the desire result:
Measure =
CALCULATE (
DISTINCTCOUNT ( 'Table'[case] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -12 ) )
) * 20
+ CALCULATE (
DISTINCTCOUNT ( 'Table'[case] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -60 ) )
) * 5
+ [Waiver Score]
If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Best regards,
Thanks for the reply. Here is what i ended up using.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |