Forum Discussion

PijanMac's avatar
PijanMac
Regular Visitor
2 years ago

TOPN DAX without filter

I have an issue with the TOPN method.  I have a table with a few columns with different Water parameters, they were filled in on different days  (so they have gaps) "InsertDate" column shows these...
TopN
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  PijanMac ,

 

You can try the following DAX:

Rank =
RANKX(    FILTER(ALL('WaterData'),'WaterData'[Tank]=MAX('WaterData'[Tank])),CALCULATE(SUM('WaterData'[HardnessF])),,DESC)
+3sigma_HardnessF_last10samples =
IF(
    SELECTEDVALUE('WaterData'[Location])="Poland",
    CALCULATE(
        AVERAGE('WaterData'[HardnessF])+
        3*STDEVX.P(
            FILTER(ALL('WaterData'),
            [Rank]<=10),[HardnessF])))

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.