Hello, I need help created a static column for Total Category Value.
I only need the total category value for 1 Quarter in my entire data set.(ex: Q2) and mark rest as 0 value.
Thanks for the suggestions!
Go to Solution.
@asalazarjr , Try a new column like
if([Quarter] ="Q2", sumx(filter(table,[Quarter] = earlier([Quarter]) && [Category] = earlier([Category])),[Value]))
Proud to be a Super User!
View solution in original post
You can use this column expression to do that
Total Category =IF ( Table[Quarter(text)] = "Q2", CALCULATE ( SUM ( Table[Value(#)] ), ALLEXCEPT ( Table, Table[Quarter(text)], Table[Category(text)] ) ), 0)
Hi @asalazarjr ,
Please let us know if the replies above are helpful.
If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please give us more details.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021