Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have a 'floor' for a tax of $50.
So where the charge is less than $50, I charge $50.
Now I want to sum all those customers where I have charged $50.
I want to sum the total tax where the equal exactly $50.00
And I also want to count the customers where the tax equal exactly $50.00.
Columns used are
Revenue PercentageShare
So Revenue X PercentageShare = Charge
where charge is les than $50 (the floor), charge $50.
and I want to do something like
CALCULATE( [Charge], FILTER( [Charge] = $50 ))
but I get the boolean true false error. Any tips?
Thanks
Solved! Go to Solution.
I don't suppose you're open to just adding an additional column?
Status = IF( 'Table'[Charge] = 50, "Modified", "Unchanged" )
Then you can use that in a Matrix letting the visual do the filtering for you with some simple Measures.
Proud to be a Super User!
Do you mean like:
Charge = IF( FLOOR('Table'[Revenue]*'Table'[PercentageShare],50) < 50, 50, 'Table'[Revenue] * 'Table'[PercentageShare] )
Proud to be a Super User!
I don't suppose you're open to just adding an additional column?
Status = IF( 'Table'[Charge] = 50, "Modified", "Unchanged" )
Then you can use that in a Matrix letting the visual do the filtering for you with some simple Measures.
Proud to be a Super User!
I am fine with any solution !!! Thanks for your help and knowledge sharing. Much appreciated.
John
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |