Forum Discussion

Moniek's avatar
Moniek
Icon for Resolver I rankResolver 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 k...
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
Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
4 years ago

Hi,

Perhaps you mean:

 

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

 

Regards