Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MeiYing
Helper I
Helper I

Hi experts, could you help to convert this Tableau expression to Power BI expression?

{FIXED [COUNTRY], [REGION], [ORDERDATE] : SUM (
IF [KPIGROSS] = 'Yes'
THEN 1
ELSE 0
END) }

 

Thank you so much. I really have no idea on how to convert.

2 REPLIES 2
johnyip
Super User
Super User

This should be dependent on how you wish to display this measure.

 

Do you want it to be displayed in a matrix/table or in a card?

You can provide some sample picture of your desired output, and the data structure as well if you can, so people can better understand the question and answer that.



Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!

Thanks John for the reply. I just want to keep it as a calculated field which will then be used to calculate an aggregation of percentage KPIGross for each week. The aggregate percentage KPI gross will be displayed as a line in bar chart. Below is the screenshot from the tableau. 

MeiYing_0-1675326606998.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.