Forum Discussion

Moniek's avatar
Moniek
Resolver I
4 years ago
Solved

Dax countrows filter

Hi, 

 

I have made the dax #mutaties with countrows of a table. I want to make a new formula that calculate the Verwacht% * total of the countrows.

For number 1: 30,1% * 2021 = 608.

Does anyone knows the dax? Thanks a lot!

 

 

Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    If Verwacht % is a measure then you could use

    Verwacht % * total =
var total = CALCULATE( [#mutaties], ALLSELECTED())
return [Verwacht %] * total

4 Replies

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    If Verwacht % is a measure then you could use

    Verwacht % * total =
var total = CALCULATE( [#mutaties], ALLSELECTED())
return [Verwacht %] * total
  • Barthel's avatar
    Barthel
    Solution Sage
    4 years ago

    Hey,

     

    This depends a bit on the broader filter context in the report. You could theoretically remove all filter context. The measure then looks like this:

     

    New formula =
[Verwacht %] * CALCULATE ( [#mutaties], REMOVEFILTERS () )

     

  • Jos_Woolley's avatar
    Jos_Woolley
    Solution Sage
    4 years ago

    Hi,

    Perhaps you mean:

     

    MyMeasure =
DIVIDE( [#mutaties], CALCULATE( [#mutaties], ALLSELECTED( 'Table' ) ) )

     

    Regards