Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I made measures
Total sale (Totalsalg),
Sale Kiwi (Salg Kiwi)
Sale Kiwi and pears=Kiwi value (Kiwi og Pærer = Kiwi Salg)
The last measure look like this: =CALCULATE([Salg Kiwi];factData[Vare]="Kiwi";factData[Vare]="Pærer")
I dont want values for apple (epler). The yellow cell should not be there. How can I make the measure?
Solved! Go to Solution.
Hi,
Try this
=IF(HASONEVALUE(factData[Vare]),IF(VALUES(factData[Vare])="Epler",Blank(),[Salg Kiwi]),[Salg Kiwi])
Hope this helps.
Hi,
Try this
=IF(HASONEVALUE(factData[Vare]),IF(VALUES(factData[Vare])="Epler",Blank(),[Salg Kiwi]),[Salg Kiwi])
Hope this helps.
Thank you very much. This work.
You are welcome.
Try this MEASURE
Measure = CALCULATE ( [Salg Kiwi], KEEPFILTERS ( factData[Vare] IN { "Kiwi", "Pærer" } ) )
Thank you. Its not working.
The values 3000 for epler has not disappered.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |