Forum Discussion

apollo89's avatar
apollo89
Helper II
6 years ago
Solved

Use DAX Measure as Categories

Consider the following table:   Name Field Value A ABC -10 A DEF 15 B ABC -20 B DEF 25 C ABC 15 D ABC 20 D DEF 25 E ABC -1 E DEF 2   I am tryi...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    These calculated column formulas work

    Total for Name = =CALCULATE(SUM(Data[Value]),FILTER(data,Data[Name]=EARLIER(Data[Name])))
    Total for all names = SUM(Data[Value])
    Threshold = 0.05*[Total for all names]
    Category = if([Total for name]>[Threshold],Data[Name],"Others")

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Share some data, describe the question and show the expected result.

barryc's avatar
barryc
Regular Visitor
5 years ago

https://1drv.ms/u/s!Am26UCUW42k4gd1lNr7zuQ2pCdEBlQ?e=gm0fF8

basically I want to show summary totals based on the status.

 

the status is dynamic based on the dates chosen.

 

so when the dates are set to show a combination of statuses

 

say 2 on active-full and two on active-partial 

 

I want to be able to show on a separate cards (or table) the totals for both statuses and have that dynamically change when the dates change.  So if dates change to make all transactions have a status of Future then we should have a total for just that status.

 

hope I'm making sense (and hope the quickly put together sample helps.