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.

barryc's avatar
barryc
Regular Visitor
5 years ago

Is there anyway to get totals by Category (relative or absolute) i.e. not requireing Name to be part of the Table visual?

For example in Relative method to select Category[Category Name] in the filter and to see 

"Others, 7"

in the table view

I.e. using a measure (that doesn't appear as a data element in the Input table)

  • 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.