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 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
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
  • Moniek's avatar
    Moniek
    Resolver I
    4 years ago

    Thanks! It works!