Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count values for multiple columns

I think the title is not clear at all. I have to explain my issue.   I have a table with few columns (9 in the screenshot below) I have to create a bar chart based on thise data. The problem...
Need Help
Tips and Tricks
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    You can try to use UnPivot to transform your data like so:

    pass Attribute Value
    xxx qa1_1_1 1
    xxx qa1_1_2 0
    xxx qa1_1_3 0
    xxx qa1_1_4 0
    ... ... ...

     

    Then, create a measure to count column "Value" for each "pass".

     

    Reference: Pivot and Unpivot with Power BI - RADACAD

     

    If this is not what you want, please give me more details.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Community Support
5 years ago

Hi Anonymous ,

 

You can try to use UnPivot to transform your data like so:

pass Attribute Value
xxx qa1_1_1 1
xxx qa1_1_2 0
xxx qa1_1_3 0
xxx qa1_1_4 0
... ... ...

 

Then, create a measure to count column "Value" for each "pass".

 

Reference: Pivot and Unpivot with Power BI - RADACAD

 

If this is not what you want, please give me more details.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.