Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Single Measure to populate Multiple Rows

Created a single measure to populate rows based on aging (Buckets 1-6) and spreadsheet ([2], [7] and CVTY [7]).  Aging bucket counts for [2] is based on Received Date, AgeNumber and COUNT(*) Aging...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Closing this topic as I figured out an extensive workaround to get the desired values to populate the matrix.

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

HEy Anonymous ,

 

do yourself a favor and use SWITCH(TRUE()) and definitely use the DAX Formatter. Then it should be possible to understand the measure.

 

Then next question, you posted one measure and refer to 6 columns. Is that measure used 6 times? Are they calculated column? How does the measure change between the 6 usages?

Make it as easy as possible, then people can help you.

 

Best regards

Denis

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I've yet to use the Switch(True()) or DAX Formatter so I'll need to read up on them.

     

    Yes, the measure is used 6 times for each calculated column with the only change being the AGE#, AgeNumber and Age Number for reference to the "bucket". Original example above is the measure used for Bucket 2 column.  The measure used for Bucket 3 column is exactly the same as the measure for Bucket 2 column the exception of the AGE#, AgeNumber and Age Number in the measure being "3"...and so on for the other Bucket column measures.