Forum Discussion

MLorenzen's avatar
MLorenzen
Frequent Visitor
4 years ago

Measures In Matrix Comprised of Multiple Datasets

Hello all,   I've been searching for an answer to a matrix problem I've been having, but I can't find a similar situation to the one I'm in and I was hoping for some insight into the issue.   Qui...
Need Help
MLorenzen's avatar
MLorenzen
Frequent Visitor
4 years ago

DataInsights, thanks for the reply and insight! DIVIDE definitely feels safer as the third parameter covers all bases.

 

However, why does that weird explosion of data happen when using a measure that just evaluates to literal text?

 

For instance, having the measure just return "Text" caused the issue I was describing. Why would that be, and is there any way to avoid that?

 

I ask because I'm trying to do something clever for implementing a URL link in the matrix's values (which I know is tricky to do) but having the text not appear in any totals. I can describe this more if necessary, but regardless the matrix behavior with the simple measure is confusing to me.

  • DataInsights's avatar
    DataInsights
    Super User
    4 years ago

    MLorenzen,

     

    I believe the explosion of data is due to the data model. Notice what happens when I use Items[Assignment ID] in the matrix using your original measure:

     

     

     

    Nonexistent combinations such as 1-A-ZZZ disappear as a result of not using the intermediate table Assignments. Power BI works best with a star schema (fact and dimension tables). There are a lot of great articles on this topic.

     

    Regarding the URL, you can use HASONEVALUE to determine if a row is a total row (and thus not display the URL).